CREATE TABLE [dbo].[OpportunityType]
(
[OpportunityTypeKey] [uniqueidentifier] NOT NULL CONSTRAINT [DF_OpportunityType_OpportunityTypeKey] DEFAULT (newid()),
[OpportunityClass] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Name] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Description] [nvarchar] (200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DefaultActionPlanKey] [uniqueidentifier] NULL,
[DefaultOwnerKey] [uniqueidentifier] NULL,
[DefaultStatus] [nvarchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[AllowCompetitorsFlag] [bit] NOT NULL CONSTRAINT [DF_OpportunityType_AllowCompetitorsFlag] DEFAULT ((0)),
[UpdatedByUserKey] [uniqueidentifier] NOT NULL,
[UpdatedOn] [datetime] NOT NULL,
[CreatedByUserKey] [uniqueidentifier] NOT NULL,
[CreatedOn] [datetime] NOT NULL,
[SystemEntityKey] [uniqueidentifier] NOT NULL,
[AccessKey] [uniqueidentifier] NOT NULL,
[MarkedForDeleteOn] [datetime] NULL,
[OwnerGroupTypeKey] [uniqueidentifier] NOT NULL,
[ContactGroupTypeKey] [uniqueidentifier] NOT NULL,
[OpportunityCreationGroupKey] [uniqueidentifier] NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[OpportunityType] ADD CONSTRAINT [PK_OpportunityType] PRIMARY KEY CLUSTERED ([OpportunityTypeKey]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_OpportunityType_AccessKey] ON [dbo].[OpportunityType] ([AccessKey]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_OpportunityType_CreatedByUserKey] ON [dbo].[OpportunityType] ([CreatedByUserKey]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_OpportunityType_DefaultActionPlanKey] ON [dbo].[OpportunityType] ([DefaultActionPlanKey]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_OpportunityType_DefaultOwnerKey] ON [dbo].[OpportunityType] ([DefaultOwnerKey]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_OpportunityType_UpdatedByUserKey] ON [dbo].[OpportunityType] ([UpdatedByUserKey]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[OpportunityType] ADD CONSTRAINT [FK_OpportunityType_AccessMain] FOREIGN KEY ([AccessKey]) REFERENCES [dbo].[AccessMain] ([AccessKey])
GO
ALTER TABLE [dbo].[OpportunityType] ADD CONSTRAINT [FK_OpportunityType_ActionPlan] FOREIGN KEY ([DefaultActionPlanKey]) REFERENCES [dbo].[ActionPlan] ([ActionPlanKey])
GO
ALTER TABLE [dbo].[OpportunityType] ADD CONSTRAINT [FK_OpportunityType_UserMain_CreatedBy] FOREIGN KEY ([CreatedByUserKey]) REFERENCES [dbo].[UserMain] ([UserKey])
GO
ALTER TABLE [dbo].[OpportunityType] ADD CONSTRAINT [FK_OpportunityType_UserMain_UpdatedBy] FOREIGN KEY ([UpdatedByUserKey]) REFERENCES [dbo].[UserMain] ([UserKey])
GO
GRANT REFERENCES ON  [dbo].[OpportunityType] TO [IMIS]
GRANT SELECT ON  [dbo].[OpportunityType] TO [IMIS]
GRANT INSERT ON  [dbo].[OpportunityType] TO [IMIS]
GRANT DELETE ON  [dbo].[OpportunityType] TO [IMIS]
GRANT UPDATE ON  [dbo].[OpportunityType] TO [IMIS]
GO